package com.wondertek.poms.dao.repo;

import com.wondertek.poms.dao.po.SyncTask;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import sun.awt.SunHints;

import java.util.List;

/**
 * <p><b>ISyncTaskDao Description:</b>  Dao 执行 的查询、修改、新增、删除操作</p>
 * <p>@author 窦再兴</p>
 * <p><b>DATE</b> 2020-10-21 13:50:43</p>
 */
@Repository
public interface ISyncTaskDao extends JpaRepository<SyncTask, Long> {

    @Query(value="select * from SYNC_TASK st where st.content_id =?1 and OPR_CODE='3' order by st.sync_time desc",nativeQuery=true)
    List<SyncTask> getLastOfflineSyncTaskByContId(String contentId);
}
